36604 - The LIBNAME statement's SQLGENERATION= option is not supported for SAS® In-Database procedures

Problem Note 36604: The LIBNAME statement's SQLGENERATION= option is not supported for SAS® In-Database procedures

Adding the SQLGENERATION= option for the LIBNAME statement provides SAS procedures with a consistent way of determining if in-database processing is supported. Without this option, the LIBNAME statement locks you into one specific value of SQLGENERATION, without a way to change that value. This behavior causes a problem for in-database processing.

The default value for the global SQLGENERATION= option is NONE, but the default value is SQLGENERATION=DBMS in the LIBNAME statement. If you use a Teradata server or a version of Teradata that is not supported by in-database processing, the following issues occur:

Setting SQLGENERATION=DBMS causes the engine to return a value of NONE.
Setting SQLGENERATION=DBMUST causes the following error message to occur:

ERROR:  In-db is not supported on this platform and version of Teradata.

There is no workaround or solution for this problem. However, the problem has been fixed in the second maintenance release of SAS 9.1 (TS2M2).

Operating System and Release Information

Product Family	Product	System	SAS Release
Product Family	Product	System	Reported	Fixed*
SAS System	SAS/ACCESS Interface to Teradata	Microsoft Windows Server 2003 Datacenter Edition	9.2 TS2M0	9.2 TS2M2
		z/OS	9.2 TS2M0	9.2 TS2M2
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS2M0	9.2 TS2M2
		Microsoft Windows Server 2003 Standard Edition	9.2 TS2M0	9.2 TS2M2
		Microsoft Windows XP Professional	9.2 TS2M0	9.2 TS2M2
		Windows Vista	9.2 TS2M0	9.2 TS2M2
		64-bit Enabled AIX	9.2 TS2M0	9.2 TS2M2
		64-bit Enabled HP-UX	9.2 TS2M0	9.2 TS2M2
		64-bit Enabled Solaris	9.2 TS2M0	9.2 TS2M2
		HP-UX IPF	9.2 TS2M0	9.2 TS2M2
		Linux	9.2 TS2M0	9.2 TS2M2
		Linux for x64	9.2 TS2M0	9.2 TS2M2
		Solaris for x64	9.2 TS2M0	9.2 TS2M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A new feature enables support for the LIBNAME statement's SQLGENERATION= option, validates it against the current database server, and returns the correct value back to the application when it is requested.

Type:	Problem Note
Priority:	high
Topic:	Data Management ==> Data Sources ==> External Databases ==> Teradata

Date Modified:	2010-05-05 12:32:36
Date Created:	2009-07-23 20:56:20

Support

Problem Note 36604: The LIBNAME statement's SQLGENERATION= option is not supported for SAS® In-Database procedures

Operating System and Release Information